DBA Data[Home] [Help]

APPS.ITG_SYNCFIELDINBOUND_PVT dependencies on ITG_DEBUG_PUB

Line 29: itg_debug_pub.Add('ENTERING PPN-Process_PoNumber',2);

25: /* Initialize return status */
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27:
28: IF (l_Debug_Level <= 2) THEN
29: itg_debug_pub.Add('ENTERING PPN-Process_PoNumber',2);
30: END IF;
31:
32: BEGIN
33: SAVEPOINT Process_PoNumber_PVT;

Line 51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);

47:
48: --Now in wrapper
49: --FND_MSG_PUB.Initialize;
50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);

Line 52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);

48: --Now in wrapper
49: --FND_MSG_PUB.Initialize;
50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;

Line 53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);

49: --FND_MSG_PUB.Initialize;
50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;
57:

Line 54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);

50: IF (l_Debug_Level <= 1) THEN
51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;
57:
58: g_action := 'Sync-field parameter validation';

Line 55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);

51: itg_debug_pub.Add('PPN - Top of procedure.' ,1);
52: itg_debug_pub.Add('PPN - p_reqid'||p_reqid ,1);
53: itg_debug_pub.Add('PPN - p_reqlinenum'||p_reqlinenum,1);
54: itg_debug_pub.Add('PPN - p_poid'||p_poid ,1);
55: itg_debug_pub.Add('PPN - p_org'||p_org ,1);
56: END IF;
57:
58: g_action := 'Sync-field parameter validation';
59:

Line 61: itg_debug_pub.Add('PPN - Validating inputs' ,1);

57:
58: g_action := 'Sync-field parameter validation';
59:
60: IF (l_Debug_Level <= 1) THEN
61: itg_debug_pub.Add('PPN - Validating inputs' ,1);
62: END IF;
63:
64: ITG_BOAPI_Utils.validate('FIELDID', NULL, NULL, FALSE, p_reqid);
65: ITG_BOAPI_Utils.validate('ORACLEITG.REQLINENUM', NULL, NULL, FALSE, p_reqlinenum);

Line 70: itg_debug_pub.Add('PPN - Updating requisition info' ,1);

66: ITG_BOAPI_Utils.validate('ORACLEITG.POID', NULL, NULL, FALSE, p_poid);
67: ITG_BOAPI_Utils.validate('ORACLEITG.POENTITY', NULL, NULL, FALSE, p_org);
68:
69: IF (l_Debug_Level <= 1) THEN
70: itg_debug_pub.Add('PPN - Updating requisition info' ,1);
71: END IF;
72: /* 2683558 : multiple po numbers from SAP for the same Req. Updates the table
73: with "," seperated. */
74:

Line 96: itg_debug_pub.Add('PPN - Update done' ,1);

92: WHERE requisition_header_id = l_req_hdr_id
93: AND line_num = p_reqlinenum;
94:
95: IF (l_Debug_Level <= 1) THEN
96: itg_debug_pub.Add('PPN - Update done' ,1);
97: END IF;
98:
99: IF SQL%ROWCOUNT <> 1 THEN
100: IF (l_Debug_Level <= 1) THEN

Line 101: itg_debug_pub.Add('PPN - Update failed' ,1);

97: END IF;
98:
99: IF SQL%ROWCOUNT <> 1 THEN
100: IF (l_Debug_Level <= 1) THEN
101: itg_debug_pub.Add('PPN - Update failed' ,1);
102: END IF;
103:
104: ITG_MSG.no_req_line(p_reqid, p_reqlinenum,p_org);
105: RAISE FND_API.G_EXC_ERROR;

Line 123: itg_debug_pub.Add('EXITING PPN-Process_PoNumber',2);

119: ITG_msg.unexpected_error(g_action);
120: END;
121:
122: IF (l_Debug_Level <= 2) THEN
123: itg_debug_pub.Add('EXITING PPN-Process_PoNumber',2);
124: END IF;
125:
126: --Removed FND_MSG_PUB.Count_And_Get
127: END Process_PoNumber;