eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_WORKFLOW_PVT dependencies on FND_MESSAGE

Line 772: -- Retrieve the message text for retrieve message from fnd_messages

768:
769: IF ((p_notif_context = 'SHARECARTNOTIF') OR
770: (p_notif_context = 'SHAREQUOTENOTIF'))THEN
771:
772: -- Retrieve the message text for retrieve message from fnd_messages
773: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');
774: l_temp_retrieve_str := 'IBE_PRMT_SC_RETRIEVE';
775: --l_temp_retrieve_str := fnd_message.get;
776:

Line 773: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');

769: IF ((p_notif_context = 'SHARECARTNOTIF') OR
770: (p_notif_context = 'SHAREQUOTENOTIF'))THEN
771:
772: -- Retrieve the message text for retrieve message from fnd_messages
773: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');
774: l_temp_retrieve_str := 'IBE_PRMT_SC_RETRIEVE';
775: --l_temp_retrieve_str := fnd_message.get;
776:
777: wf_engine.SetItemAttrText(

Line 775: --l_temp_retrieve_str := fnd_message.get;

771:
772: -- Retrieve the message text for retrieve message from fnd_messages
773: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');
774: l_temp_retrieve_str := 'IBE_PRMT_SC_RETRIEVE';
775: --l_temp_retrieve_str := fnd_message.get;
776:
777: wf_engine.SetItemAttrText(
778: itemtype => g_ItemType,
779: itemkey => p_item_key,

Line 1205: FND_MESSAGE.set_name('IBE',document_id);

1201: BEGIN
1202: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1203: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);
1204: END IF;
1205: FND_MESSAGE.set_name('IBE',document_id);
1206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1207: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1208: END IF;
1209: document:=FND_MESSAGE.get();

Line 1207: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');

1203: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);
1204: END IF;
1205: FND_MESSAGE.set_name('IBE',document_id);
1206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1207: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1208: END IF;
1209: document:=FND_MESSAGE.get();
1210: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1211: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);

Line 1209: document:=FND_MESSAGE.get();

1205: FND_MESSAGE.set_name('IBE',document_id);
1206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1207: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1208: END IF;
1209: document:=FND_MESSAGE.get();
1210: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1211: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);
1212: END IF;
1213: document_type := 'text/plain';

Line 1211: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);

1207: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1208: END IF;
1209: document:=FND_MESSAGE.get();
1210: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1211: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);
1212: END IF;
1213: document_type := 'text/plain';
1214: EXCEPTION
1215: WHEN OTHERS THEN

Line 1252: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');

1248: document := ' ';
1249:
1250: IF l_passwd is not null THEN
1251:
1252: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1253: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1254: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1255: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1256: l_credential_line := ' ' || FND_MESSAGE.get();

Line 1253: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);

1249:
1250: IF l_passwd is not null THEN
1251:
1252: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1253: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1254: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1255: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1256: l_credential_line := ' ' || FND_MESSAGE.get();
1257: ELSE

Line 1254: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');

1250: IF l_passwd is not null THEN
1251:
1252: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1253: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1254: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1255: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1256: l_credential_line := ' ' || FND_MESSAGE.get();
1257: ELSE
1258: l_credential_line := ' ';

Line 1255: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);

1251:
1252: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1253: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1254: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1255: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1256: l_credential_line := ' ' || FND_MESSAGE.get();
1257: ELSE
1258: l_credential_line := ' ';
1259:

Line 1256: l_credential_line := ' ' || FND_MESSAGE.get();

1252: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1253: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1254: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1255: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1256: l_credential_line := ' ' || FND_MESSAGE.get();
1257: ELSE
1258: l_credential_line := ' ';
1259:
1260: END IF;

Line 1444: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));

1440: ELSIF (l_UserType='IBE_PARTNER_PRIMARY') OR (l_UserType='IBE_PARTNER_BUSINESS') THEN
1441: l_approval_msg_name:='IBE_APPRVL_REQD_PRM';
1442: ELSE
1443: l_approval_msg_name:= l_UserType||'_APPR';
1444: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1445: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1446: l_approval_msg_name:='IBE_APPRVL_REQD_CUST';
1447: End if;
1448: END IF;

Line 1445: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then

1441: l_approval_msg_name:='IBE_APPRVL_REQD_PRM';
1442: ELSE
1443: l_approval_msg_name:= l_UserType||'_APPR';
1444: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1445: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1446: l_approval_msg_name:='IBE_APPRVL_REQD_CUST';
1447: End if;
1448: END IF;
1449: ELSE --approval not associated with the user type

Line 1459: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));

1455: ELSIF (l_UserType='IBE_PARTNER_PRIMARY') OR (l_UserType='IBE_PARTNER_BUSINESS') THEN
1456: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_PRM';
1457: ELSE
1458: l_approval_msg_name:= l_UserType||'_NOAPPR';
1459: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1460: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1461: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_CUST';
1462: End if;
1463: END IF;

Line 1460: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then

1456: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_PRM';
1457: ELSE
1458: l_approval_msg_name:= l_UserType||'_NOAPPR';
1459: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1460: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1461: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_CUST';
1462: End if;
1463: END IF;
1464: END IF;

Line 5335: -- Retrieve the message text for update message from fnd_messages

5331: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5332: IBE_UTIL.DEBUG('Notify_shared_cart:retrieving message mapping');
5333: END IF;
5334:
5335: -- Retrieve the message text for update message from fnd_messages
5336:
5337: IBE_WF_MSG_MAPPING_PVT.Retrieve_Msg_Mapping
5338: (
5339: p_org_id => l_OrgId,

Line 5599: -- Retrieve the message text for update message from fnd_messages

5595: IBE_UTIL.DEBUG('Notify_access_change:After message mapping call:l_MessageName: '||l_MessageName);
5596: IBE_UTIL.DEBUG('Notify_access_change:l_msgEnabled: '||l_msgEnabled);
5597: END IF;
5598:
5599: -- Retrieve the message text for update message from fnd_messages
5600: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5601: l_temp_update_str := FND_API.G_MISS_CHAR;
5602: l_temp_update_str := fnd_message.get;
5603: --l_msgEnabled := 'Y';

Line 5600: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');

5596: IBE_UTIL.DEBUG('Notify_access_change:l_msgEnabled: '||l_msgEnabled);
5597: END IF;
5598:
5599: -- Retrieve the message text for update message from fnd_messages
5600: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5601: l_temp_update_str := FND_API.G_MISS_CHAR;
5602: l_temp_update_str := fnd_message.get;
5603: --l_msgEnabled := 'Y';
5604: IF l_msgEnabled = 'Y' THEN

Line 5602: l_temp_update_str := fnd_message.get;

5598:
5599: -- Retrieve the message text for update message from fnd_messages
5600: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5601: l_temp_update_str := FND_API.G_MISS_CHAR;
5602: l_temp_update_str := fnd_message.get;
5603: --l_msgEnabled := 'Y';
5604: IF l_msgEnabled = 'Y' THEN
5605: l_url := p_url;
5606: l_url := l_url||p_quote_access_rec.quote_sharee_number;

Line 6441: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6437: END IF;
6438:
6439: IF ( l_event_type = 'ORDFAX' OR l_event_type = 'ORDCONF' OR l_event_type = 'CNCLORDR' OR l_event_type = 'RETURNORDER') THEN
6440: -- IF (display_type = 'text/plain' ) THEN
6441: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6442: l_temp_str := null;
6443: l_temp_str := fnd_message.get;
6444: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6445: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

Line 6443: l_temp_str := fnd_message.get;

6439: IF ( l_event_type = 'ORDFAX' OR l_event_type = 'ORDCONF' OR l_event_type = 'CNCLORDR' OR l_event_type = 'RETURNORDER') THEN
6440: -- IF (display_type = 'text/plain' ) THEN
6441: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6442: l_temp_str := null;
6443: l_temp_str := fnd_message.get;
6444: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6445: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6446: l_temp_str := null;
6447: l_temp_str := fnd_message.get;

Line 6445: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

6441: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6442: l_temp_str := null;
6443: l_temp_str := fnd_message.get;
6444: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6445: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6446: l_temp_str := null;
6447: l_temp_str := fnd_message.get;
6448: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6449: IF l_event_type <> 'RETURNORDER' THEN

Line 6447: l_temp_str := fnd_message.get;

6443: l_temp_str := fnd_message.get;
6444: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6445: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6446: l_temp_str := null;
6447: l_temp_str := fnd_message.get;
6448: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6449: IF l_event_type <> 'RETURNORDER' THEN
6450: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6451: l_temp_str := null;

Line 6450: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

6446: l_temp_str := null;
6447: l_temp_str := fnd_message.get;
6448: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6449: IF l_event_type <> 'RETURNORDER' THEN
6450: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6451: l_temp_str := null;
6452: l_temp_str := fnd_message.get;
6453: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_Ship_Method||NEWLINE;
6454: END IF;

Line 6452: l_temp_str := fnd_message.get;

6448: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6449: IF l_event_type <> 'RETURNORDER' THEN
6450: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6451: l_temp_str := null;
6452: l_temp_str := fnd_message.get;
6453: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_Ship_Method||NEWLINE;
6454: END IF;
6455: -- Need to get the user type. For individual users, show address, for others skip.
6456: l_user_type := wf_engine.GetItemAttrText (

Line 6463: fnd_message.set_name('IBE','IBE_PRMT_SHIP_INFO_COLON');

6459: aname => 'STOREUSERTYPE'
6460: );
6461: IF ((l_user_type = 'IBE_INDIVIDUAL'and l_event_type = 'RETURNORDER') or (l_event_type <> 'RETURNORDER')) THEN
6462: IF (l_event_type <> 'RETURNORDER') THEN
6463: fnd_message.set_name('IBE','IBE_PRMT_SHIP_INFO_COLON');
6464: l_temp_str := null;
6465: l_temp_str := fnd_message.get;
6466:
6467: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;

Line 6465: l_temp_str := fnd_message.get;

6461: IF ((l_user_type = 'IBE_INDIVIDUAL'and l_event_type = 'RETURNORDER') or (l_event_type <> 'RETURNORDER')) THEN
6462: IF (l_event_type <> 'RETURNORDER') THEN
6463: fnd_message.set_name('IBE','IBE_PRMT_SHIP_INFO_COLON');
6464: l_temp_str := null;
6465: l_temp_str := fnd_message.get;
6466:
6467: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;
6468: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_address1||NEWLINE;
6469: IF ( rtrim(g_header_rec.ship_to_address2) IS NOT NULL ) THEN

Line 6484: fnd_message.set_name('IBE','IBE_EOS_BILLING_ADDRESS_COLON');

6480: l_document := l_document || g_header_rec.ship_to_postal_code||NEWLINE;
6481: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_country;
6482:
6483: ELSE ---3334542
6484: fnd_message.set_name('IBE','IBE_EOS_BILLING_ADDRESS_COLON');
6485: l_temp_str := null;
6486: l_temp_str := fnd_message.get;
6487:
6488: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;

Line 6486: l_temp_str := fnd_message.get;

6482:
6483: ELSE ---3334542
6484: fnd_message.set_name('IBE','IBE_EOS_BILLING_ADDRESS_COLON');
6485: l_temp_str := null;
6486: l_temp_str := fnd_message.get;
6487:
6488: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;
6489: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.bill_to_address1||NEWLINE;
6490: IF ( rtrim(g_header_rec.bill_to_address2) IS NOT NULL ) THEN

Line 6512: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6508: --null;
6509: --END IF;
6510: ELSIF ( l_event_type = 'ORDERROR') THEN
6511: -- IF (display_type = 'text/plain' ) THEN
6512: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6513: l_temp_str := null;
6514: l_temp_str := fnd_message.get;
6515: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6516: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');

Line 6514: l_temp_str := fnd_message.get;

6510: ELSIF ( l_event_type = 'ORDERROR') THEN
6511: -- IF (display_type = 'text/plain' ) THEN
6512: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6513: l_temp_str := null;
6514: l_temp_str := fnd_message.get;
6515: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6516: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6517: l_temp_str := null;
6518: l_temp_str := fnd_message.get;

Line 6516: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');

6512: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6513: l_temp_str := null;
6514: l_temp_str := fnd_message.get;
6515: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6516: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6517: l_temp_str := null;
6518: l_temp_str := fnd_message.get;
6519: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6520: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');

Line 6518: l_temp_str := fnd_message.get;

6514: l_temp_str := fnd_message.get;
6515: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6516: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6517: l_temp_str := null;
6518: l_temp_str := fnd_message.get;
6519: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6520: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6521: l_temp_str := null;
6522: l_temp_str := fnd_message.get;

Line 6520: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');

6516: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6517: l_temp_str := null;
6518: l_temp_str := fnd_message.get;
6519: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6520: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6521: l_temp_str := null;
6522: l_temp_str := fnd_message.get;
6523: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6524: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');

Line 6522: l_temp_str := fnd_message.get;

6518: l_temp_str := fnd_message.get;
6519: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6520: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6521: l_temp_str := null;
6522: l_temp_str := fnd_message.get;
6523: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6524: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6525: l_temp_str := null;
6526: l_temp_str := fnd_message.get;

Line 6524: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');

6520: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6521: l_temp_str := null;
6522: l_temp_str := fnd_message.get;
6523: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6524: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6525: l_temp_str := null;
6526: l_temp_str := fnd_message.get;
6527: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6528: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');

Line 6526: l_temp_str := fnd_message.get;

6522: l_temp_str := fnd_message.get;
6523: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6524: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6525: l_temp_str := null;
6526: l_temp_str := fnd_message.get;
6527: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6528: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');
6529: l_temp_str := null;
6530: l_temp_str := fnd_message.get;

Line 6528: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');

6524: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6525: l_temp_str := null;
6526: l_temp_str := fnd_message.get;
6527: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6528: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');
6529: l_temp_str := null;
6530: l_temp_str := fnd_message.get;
6531: l_document := l_document || l_temp_str||TAB||TAB ||g_header_rec.ordered_date||NEWLINE;
6532: -- Need to restrict the end user to view the net price.

Line 6530: l_temp_str := fnd_message.get;

6526: l_temp_str := fnd_message.get;
6527: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6528: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');
6529: l_temp_str := null;
6530: l_temp_str := fnd_message.get;
6531: l_document := l_document || l_temp_str||TAB||TAB ||g_header_rec.ordered_date||NEWLINE;
6532: -- Need to restrict the end user to view the net price.
6533:
6534: l_view_net_price_flag := wf_engine.GetItemAttrText (

Line 6541: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');

6537: aname => 'VIEWNETPRICE'
6538: );
6539:
6540: IF l_view_net_price_flag = 'Y' THEN
6541: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');
6542: l_temp_str := null;
6543: l_temp_str := fnd_message.get;
6544: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6545: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');

Line 6543: l_temp_str := fnd_message.get;

6539:
6540: IF l_view_net_price_flag = 'Y' THEN
6541: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');
6542: l_temp_str := null;
6543: l_temp_str := fnd_message.get;
6544: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6545: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');
6546: l_temp_str := null;
6547: l_temp_str := fnd_message.get;

Line 6545: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');

6541: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');
6542: l_temp_str := null;
6543: l_temp_str := fnd_message.get;
6544: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6545: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');
6546: l_temp_str := null;
6547: l_temp_str := fnd_message.get;
6548: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6549: END IF;

Line 6547: l_temp_str := fnd_message.get;

6543: l_temp_str := fnd_message.get;
6544: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6545: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');
6546: l_temp_str := null;
6547: l_temp_str := fnd_message.get;
6548: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6549: END IF;
6550: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');
6551: l_temp_str := null;

Line 6550: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');

6546: l_temp_str := null;
6547: l_temp_str := fnd_message.get;
6548: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6549: END IF;
6550: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');
6551: l_temp_str := null;
6552: l_temp_str := fnd_message.get;
6553: l_document := l_document || l_temp_str ||TAB||TAB || NEWLINE ;
6554: l_document := l_document ||TAB||TAB||TAB|| l_errmsg_data ||NEWLINE;

Line 6552: l_temp_str := fnd_message.get;

6548: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6549: END IF;
6550: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');
6551: l_temp_str := null;
6552: l_temp_str := fnd_message.get;
6553: l_document := l_document || l_temp_str ||TAB||TAB || NEWLINE ;
6554: l_document := l_document ||TAB||TAB||TAB|| l_errmsg_data ||NEWLINE;
6555: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6556: ibe_util.debug('Error Message '|| l_errmsg_data);

Line 6748: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');

6744: End Loop;
6745:
6746: IF ( l_event_type = 'CUSTASSIST' ) THEN
6747: --IF ( display_type = 'text/plain' ) THEN
6748: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6749: l_temp_str := null;
6750: l_temp_str := fnd_message.get;
6751: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6752:

Line 6750: l_temp_str := fnd_message.get;

6746: IF ( l_event_type = 'CUSTASSIST' ) THEN
6747: --IF ( display_type = 'text/plain' ) THEN
6748: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6749: l_temp_str := null;
6750: l_temp_str := fnd_message.get;
6751: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6752:
6753: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6754: l_temp_str := null;

Line 6753: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6749: l_temp_str := null;
6750: l_temp_str := fnd_message.get;
6751: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6752:
6753: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6754: l_temp_str := null;
6755: l_temp_str := fnd_message.get;
6756: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6757:

Line 6755: l_temp_str := fnd_message.get;

6751: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6752:
6753: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6754: l_temp_str := null;
6755: l_temp_str := fnd_message.get;
6756: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6757:
6758: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6759: l_temp_str := null;

Line 6758: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');

6754: l_temp_str := null;
6755: l_temp_str := fnd_message.get;
6756: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6757:
6758: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6759: l_temp_str := null;
6760: l_temp_str := fnd_message.get;
6761: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6762:

Line 6760: l_temp_str := fnd_message.get;

6756: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6757:
6758: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6759: l_temp_str := null;
6760: l_temp_str := fnd_message.get;
6761: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6762:
6763: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6764: l_temp_str := null;

Line 6763: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');

6759: l_temp_str := null;
6760: l_temp_str := fnd_message.get;
6761: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6762:
6763: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6764: l_temp_str := null;
6765: l_temp_str := fnd_message.get;
6766: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6767:

Line 6765: l_temp_str := fnd_message.get;

6761: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6762:
6763: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6764: l_temp_str := null;
6765: l_temp_str := fnd_message.get;
6766: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6767:
6768: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6769: l_temp_str := null;

Line 6768: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');

6764: l_temp_str := null;
6765: l_temp_str := fnd_message.get;
6766: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6767:
6768: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6769: l_temp_str := null;
6770: l_temp_str := fnd_message.get;
6771: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6772:

Line 6770: l_temp_str := fnd_message.get;

6766: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6767:
6768: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6769: l_temp_str := null;
6770: l_temp_str := fnd_message.get;
6771: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6772:
6773: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6774: l_temp_str := null;

Line 6773: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6769: l_temp_str := null;
6770: l_temp_str := fnd_message.get;
6771: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6772:
6773: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6774: l_temp_str := null;
6775: l_temp_str := fnd_message.get;
6776: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6777:

Line 6775: l_temp_str := fnd_message.get;

6771: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6772:
6773: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6774: l_temp_str := null;
6775: l_temp_str := fnd_message.get;
6776: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6777:
6778: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6779: l_temp_str := null;

Line 6778: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

6774: l_temp_str := null;
6775: l_temp_str := fnd_message.get;
6776: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6777:
6778: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6779: l_temp_str := null;
6780: l_temp_str := fnd_message.get;
6781: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6782:

Line 6780: l_temp_str := fnd_message.get;

6776: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6777:
6778: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6779: l_temp_str := null;
6780: l_temp_str := fnd_message.get;
6781: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6782:
6783: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6784: l_temp_str := null;

Line 6783: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

6779: l_temp_str := null;
6780: l_temp_str := fnd_message.get;
6781: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6782:
6783: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6784: l_temp_str := null;
6785: l_temp_str := fnd_message.get;
6786: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6787:

Line 6785: l_temp_str := fnd_message.get;

6781: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6782:
6783: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6784: l_temp_str := null;
6785: l_temp_str := fnd_message.get;
6786: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6787:
6788: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6789: l_temp_str := null;

Line 6788: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

6784: l_temp_str := null;
6785: l_temp_str := fnd_message.get;
6786: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6787:
6788: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6789: l_temp_str := null;
6790: l_temp_str := fnd_message.get;
6791: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6792: l_document := l_document || TAB||TAB||TAB||TAB||l_ship_address||NEWLINE;

Line 6790: l_temp_str := fnd_message.get;

6786: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6787:
6788: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6789: l_temp_str := null;
6790: l_temp_str := fnd_message.get;
6791: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6792: l_document := l_document || TAB||TAB||TAB||TAB||l_ship_address||NEWLINE;
6793: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6794: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_state||' ';

Line 6802: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6798: --null;
6799: --END IF;
6800: ELSIF ( l_event_type = 'SALESASSIST' ) THEN
6801: --IF (display_type = 'text/plain' ) THEN
6802: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6803: l_temp_str := null;
6804: l_temp_str := fnd_message.get;
6805: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6806:

Line 6804: l_temp_str := fnd_message.get;

6800: ELSIF ( l_event_type = 'SALESASSIST' ) THEN
6801: --IF (display_type = 'text/plain' ) THEN
6802: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6803: l_temp_str := null;
6804: l_temp_str := fnd_message.get;
6805: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6806:
6807: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6808: l_temp_str := null;

Line 6807: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');

6803: l_temp_str := null;
6804: l_temp_str := fnd_message.get;
6805: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6806:
6807: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6808: l_temp_str := null;
6809: l_temp_str := fnd_message.get;
6810: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6811:

Line 6809: l_temp_str := fnd_message.get;

6805: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6806:
6807: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6808: l_temp_str := null;
6809: l_temp_str := fnd_message.get;
6810: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6811:
6812: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6813: l_temp_str := null;

Line 6812: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

6808: l_temp_str := null;
6809: l_temp_str := fnd_message.get;
6810: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6811:
6812: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6813: l_temp_str := null;
6814: l_temp_str := fnd_message.get;
6815: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6816:

Line 6814: l_temp_str := fnd_message.get;

6810: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6811:
6812: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6813: l_temp_str := null;
6814: l_temp_str := fnd_message.get;
6815: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6816:
6817: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6818: l_temp_str := null;

Line 6817: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

6813: l_temp_str := null;
6814: l_temp_str := fnd_message.get;
6815: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6816:
6817: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6818: l_temp_str := null;
6819: l_temp_str := fnd_message.get;
6820: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6821:

Line 6819: l_temp_str := fnd_message.get;

6815: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6816:
6817: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6818: l_temp_str := null;
6819: l_temp_str := fnd_message.get;
6820: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6821:
6822: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6823: l_temp_str := null;

Line 6822: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');

6818: l_temp_str := null;
6819: l_temp_str := fnd_message.get;
6820: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6821:
6822: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6823: l_temp_str := null;
6824: l_temp_str := fnd_message.get;
6825: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6826:

Line 6824: l_temp_str := fnd_message.get;

6820: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6821:
6822: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6823: l_temp_str := null;
6824: l_temp_str := fnd_message.get;
6825: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6826:
6827: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6828: l_temp_str := null;

Line 6827: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6823: l_temp_str := null;
6824: l_temp_str := fnd_message.get;
6825: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6826:
6827: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6828: l_temp_str := null;
6829: l_temp_str := fnd_message.get;
6830: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6831:

Line 6829: l_temp_str := fnd_message.get;

6825: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6826:
6827: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6828: l_temp_str := null;
6829: l_temp_str := fnd_message.get;
6830: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6831:
6832: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6833: l_temp_str := null;

Line 6832: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');

6828: l_temp_str := null;
6829: l_temp_str := fnd_message.get;
6830: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6831:
6832: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6833: l_temp_str := null;
6834: l_temp_str := fnd_message.get;
6835: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6836:

Line 6834: l_temp_str := fnd_message.get;

6830: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6831:
6832: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6833: l_temp_str := null;
6834: l_temp_str := fnd_message.get;
6835: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6836:
6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6838: l_temp_str := null;

Line 6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');

6833: l_temp_str := null;
6834: l_temp_str := fnd_message.get;
6835: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6836:
6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6838: l_temp_str := null;
6839: l_temp_str := fnd_message.get;
6840: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6841:

Line 6839: l_temp_str := fnd_message.get;

6835: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6836:
6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6838: l_temp_str := null;
6839: l_temp_str := fnd_message.get;
6840: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6841:
6842: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6843: l_temp_str := null;

Line 6842: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');

6838: l_temp_str := null;
6839: l_temp_str := fnd_message.get;
6840: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6841:
6842: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6843: l_temp_str := null;
6844: l_temp_str := fnd_message.get;
6845: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6846:

Line 6844: l_temp_str := fnd_message.get;

6840: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6841:
6842: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6843: l_temp_str := null;
6844: l_temp_str := fnd_message.get;
6845: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6846:
6847: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
6848: l_temp_str := null;

Line 6847: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');

6843: l_temp_str := null;
6844: l_temp_str := fnd_message.get;
6845: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6846:
6847: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
6848: l_temp_str := null;
6849: l_temp_str := fnd_message.get;
6850: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6851:

Line 6849: l_temp_str := fnd_message.get;

6845: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6846:
6847: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
6848: l_temp_str := null;
6849: l_temp_str := fnd_message.get;
6850: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6851:
6852: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6853: l_temp_str := null;

Line 6852: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

6848: l_temp_str := null;
6849: l_temp_str := fnd_message.get;
6850: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6851:
6852: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6853: l_temp_str := null;
6854: l_temp_str := fnd_message.get;
6855: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6856:

Line 6854: l_temp_str := fnd_message.get;

6850: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6851:
6852: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6853: l_temp_str := null;
6854: l_temp_str := fnd_message.get;
6855: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6856:
6857: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6858: l_temp_str := null;

Line 6857: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

6853: l_temp_str := null;
6854: l_temp_str := fnd_message.get;
6855: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6856:
6857: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6858: l_temp_str := null;
6859: l_temp_str := fnd_message.get;
6860: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6861:

Line 6859: l_temp_str := fnd_message.get;

6855: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6856:
6857: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6858: l_temp_str := null;
6859: l_temp_str := fnd_message.get;
6860: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6861:
6862: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6863: l_temp_str := null;

Line 6862: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

6858: l_temp_str := null;
6859: l_temp_str := fnd_message.get;
6860: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6861:
6862: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6863: l_temp_str := null;
6864: l_temp_str := fnd_message.get;
6865: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6866:

Line 6864: l_temp_str := fnd_message.get;

6860: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6861:
6862: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6863: l_temp_str := null;
6864: l_temp_str := fnd_message.get;
6865: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6866:
6867: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6868: l_temp_str := null;

Line 6867: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

6863: l_temp_str := null;
6864: l_temp_str := fnd_message.get;
6865: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6866:
6867: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6868: l_temp_str := null;
6869: l_temp_str := fnd_message.get;
6870: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6871:

Line 6869: l_temp_str := fnd_message.get;

6865: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6866:
6867: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6868: l_temp_str := null;
6869: l_temp_str := fnd_message.get;
6870: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6871:
6872: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6873: l_temp_str := null;

Line 6872: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');

6868: l_temp_str := null;
6869: l_temp_str := fnd_message.get;
6870: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6871:
6872: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6873: l_temp_str := null;
6874: l_temp_str := fnd_message.get;
6875: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6876:

Line 6874: l_temp_str := fnd_message.get;

6870: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6871:
6872: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6873: l_temp_str := null;
6874: l_temp_str := fnd_message.get;
6875: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6876:
6877: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6878: l_temp_str := null;

Line 6877: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

6873: l_temp_str := null;
6874: l_temp_str := fnd_message.get;
6875: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6876:
6877: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6878: l_temp_str := null;
6879: l_temp_str := fnd_message.get;
6880: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6881:

Line 6879: l_temp_str := fnd_message.get;

6875: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6876:
6877: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6878: l_temp_str := null;
6879: l_temp_str := fnd_message.get;
6880: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6881:
6882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6883: l_temp_str := null;

Line 6882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6878: l_temp_str := null;
6879: l_temp_str := fnd_message.get;
6880: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6881:
6882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6883: l_temp_str := null;
6884: l_temp_str := fnd_message.get;
6885: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6886:

Line 6884: l_temp_str := fnd_message.get;

6880: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6881:
6882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6883: l_temp_str := null;
6884: l_temp_str := fnd_message.get;
6885: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6886:
6887: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6888: l_temp_str := null;

Line 6887: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

6883: l_temp_str := null;
6884: l_temp_str := fnd_message.get;
6885: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6886:
6887: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6888: l_temp_str := null;
6889: l_temp_str := fnd_message.get;
6890: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6891:

Line 6889: l_temp_str := fnd_message.get;

6885: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6886:
6887: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6888: l_temp_str := null;
6889: l_temp_str := fnd_message.get;
6890: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6891:
6892: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6893: l_temp_str := null;

Line 6892: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

6888: l_temp_str := null;
6889: l_temp_str := fnd_message.get;
6890: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6891:
6892: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6893: l_temp_str := null;
6894: l_temp_str := fnd_message.get;
6895: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6896:

Line 6894: l_temp_str := fnd_message.get;

6890: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6891:
6892: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6893: l_temp_str := null;
6894: l_temp_str := fnd_message.get;
6895: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6896:
6897: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
6898: l_temp_str := null;

Line 6897: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');

6893: l_temp_str := null;
6894: l_temp_str := fnd_message.get;
6895: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6896:
6897: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
6898: l_temp_str := null;
6899: l_temp_str := fnd_message.get;
6900: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6901:

Line 6899: l_temp_str := fnd_message.get;

6895: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6896:
6897: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
6898: l_temp_str := null;
6899: l_temp_str := fnd_message.get;
6900: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6901:
6902: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6903: l_temp_str := null;

Line 6902: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

6898: l_temp_str := null;
6899: l_temp_str := fnd_message.get;
6900: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6901:
6902: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6903: l_temp_str := null;
6904: l_temp_str := fnd_message.get;
6905: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6906:

Line 6904: l_temp_str := fnd_message.get;

6900: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6901:
6902: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6903: l_temp_str := null;
6904: l_temp_str := fnd_message.get;
6905: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6906:
6907: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6908: l_temp_str := null;

Line 6907: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

6903: l_temp_str := null;
6904: l_temp_str := fnd_message.get;
6905: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6906:
6907: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6908: l_temp_str := null;
6909: l_temp_str := fnd_message.get;
6910: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6911:

Line 6909: l_temp_str := fnd_message.get;

6905: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6906:
6907: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6908: l_temp_str := null;
6909: l_temp_str := fnd_message.get;
6910: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6911:
6912: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6913: l_temp_str := null;

Line 6912: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

6908: l_temp_str := null;
6909: l_temp_str := fnd_message.get;
6910: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6911:
6912: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6913: l_temp_str := null;
6914: l_temp_str := fnd_message.get;
6915: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6916:

Line 6914: l_temp_str := fnd_message.get;

6910: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6911:
6912: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6913: l_temp_str := null;
6914: l_temp_str := fnd_message.get;
6915: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6916:
6917: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6918: l_temp_str := null;

Line 6917: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

6913: l_temp_str := null;
6914: l_temp_str := fnd_message.get;
6915: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6916:
6917: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6918: l_temp_str := null;
6919: l_temp_str := fnd_message.get;
6920: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6921:

Line 6919: l_temp_str := fnd_message.get;

6915: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6916:
6917: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6918: l_temp_str := null;
6919: l_temp_str := fnd_message.get;
6920: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6921:
6922: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6923: l_temp_str := null;

Line 6922: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');

6918: l_temp_str := null;
6919: l_temp_str := fnd_message.get;
6920: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6921:
6922: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6923: l_temp_str := null;
6924: l_temp_str := fnd_message.get;
6925: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6926:

Line 6924: l_temp_str := fnd_message.get;

6920: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6921:
6922: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6923: l_temp_str := null;
6924: l_temp_str := fnd_message.get;
6925: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6926:
6927: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6928: l_temp_str := null;

Line 6927: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

6923: l_temp_str := null;
6924: l_temp_str := fnd_message.get;
6925: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6926:
6927: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6928: l_temp_str := null;
6929: l_temp_str := fnd_message.get;
6930: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6931:

Line 6929: l_temp_str := fnd_message.get;

6925: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6926:
6927: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6928: l_temp_str := null;
6929: l_temp_str := fnd_message.get;
6930: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6931:
6932: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6933: l_temp_str := null;

Line 6932: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6928: l_temp_str := null;
6929: l_temp_str := fnd_message.get;
6930: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6931:
6932: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6933: l_temp_str := null;
6934: l_temp_str := fnd_message.get;
6935: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6936:

Line 6934: l_temp_str := fnd_message.get;

6930: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6931:
6932: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6933: l_temp_str := null;
6934: l_temp_str := fnd_message.get;
6935: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6936:
6937: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6938: l_temp_str := null;

Line 6937: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

6933: l_temp_str := null;
6934: l_temp_str := fnd_message.get;
6935: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6936:
6937: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6938: l_temp_str := null;
6939: l_temp_str := fnd_message.get;
6940: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6941:

Line 6939: l_temp_str := fnd_message.get;

6935: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6936:
6937: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6938: l_temp_str := null;
6939: l_temp_str := fnd_message.get;
6940: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6941:
6942: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6943: l_temp_str := null;

Line 6942: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

6938: l_temp_str := null;
6939: l_temp_str := fnd_message.get;
6940: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6941:
6942: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6943: l_temp_str := null;
6944: l_temp_str := fnd_message.get;
6945: l_document := l_document || l_temp_str||TAB||TAB||l_contact_fax||NEWLINE;
6946: --ELSE

Line 6944: l_temp_str := fnd_message.get;

6940: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6941:
6942: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6943: l_temp_str := null;
6944: l_temp_str := fnd_message.get;
6945: l_document := l_document || l_temp_str||TAB||TAB||l_contact_fax||NEWLINE;
6946: --ELSE
6947: --null;
6948: --END IF;

Line 7029: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

7025: itemkey => l_item_key,
7026: aname => 'QUOTEID');
7027:
7028: IF (l_event_type = 'RETURNORDER') THEN -- For Return Order WF Notification
7029: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7030: l_temp_str := null;
7031: l_temp_str := fnd_message.get;
7032: l_document := rpad(l_temp_str,7)||' ';
7033: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');

Line 7031: l_temp_str := fnd_message.get;

7027:
7028: IF (l_event_type = 'RETURNORDER') THEN -- For Return Order WF Notification
7029: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7030: l_temp_str := null;
7031: l_temp_str := fnd_message.get;
7032: l_document := rpad(l_temp_str,7)||' ';
7033: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
7034: l_temp_str := null;
7035: l_temp_str := fnd_message.get;

Line 7033: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');

7029: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7030: l_temp_str := null;
7031: l_temp_str := fnd_message.get;
7032: l_document := rpad(l_temp_str,7)||' ';
7033: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
7034: l_temp_str := null;
7035: l_temp_str := fnd_message.get;
7036: l_document := l_document||rpad(l_temp_str,20)||' ';
7037: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');

Line 7035: l_temp_str := fnd_message.get;

7031: l_temp_str := fnd_message.get;
7032: l_document := rpad(l_temp_str,7)||' ';
7033: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
7034: l_temp_str := null;
7035: l_temp_str := fnd_message.get;
7036: l_document := l_document||rpad(l_temp_str,20)||' ';
7037: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
7038: l_temp_str := null;
7039: l_temp_str := fnd_message.get;

Line 7037: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');

7033: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
7034: l_temp_str := null;
7035: l_temp_str := fnd_message.get;
7036: l_document := l_document||rpad(l_temp_str,20)||' ';
7037: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
7038: l_temp_str := null;
7039: l_temp_str := fnd_message.get;
7040: l_document := l_document||rpad(l_temp_str,9)||' ';
7041: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

Line 7039: l_temp_str := fnd_message.get;

7035: l_temp_str := fnd_message.get;
7036: l_document := l_document||rpad(l_temp_str,20)||' ';
7037: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
7038: l_temp_str := null;
7039: l_temp_str := fnd_message.get;
7040: l_document := l_document||rpad(l_temp_str,9)||' ';
7041: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7042: l_temp_str := null;
7043: l_temp_str := fnd_message.get;

Line 7041: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

7037: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
7038: l_temp_str := null;
7039: l_temp_str := fnd_message.get;
7040: l_document := l_document||rpad(l_temp_str,9)||' ';
7041: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7042: l_temp_str := null;
7043: l_temp_str := fnd_message.get;
7044: l_document := l_document||rpad(l_temp_str,4)||' ';
7045: IF l_view_net_price_flag = 'Y' THEN

Line 7043: l_temp_str := fnd_message.get;

7039: l_temp_str := fnd_message.get;
7040: l_document := l_document||rpad(l_temp_str,9)||' ';
7041: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7042: l_temp_str := null;
7043: l_temp_str := fnd_message.get;
7044: l_document := l_document||rpad(l_temp_str,4)||' ';
7045: IF l_view_net_price_flag = 'Y' THEN
7046: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');
7047: l_temp_str := null;

Line 7046: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');

7042: l_temp_str := null;
7043: l_temp_str := fnd_message.get;
7044: l_document := l_document||rpad(l_temp_str,4)||' ';
7045: IF l_view_net_price_flag = 'Y' THEN
7046: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');
7047: l_temp_str := null;
7048: l_temp_str := fnd_message.get;
7049: l_document := l_document||rpad(l_temp_str,15)||' ';
7050: END IF;

Line 7048: l_temp_str := fnd_message.get;

7044: l_document := l_document||rpad(l_temp_str,4)||' ';
7045: IF l_view_net_price_flag = 'Y' THEN
7046: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');
7047: l_temp_str := null;
7048: l_temp_str := fnd_message.get;
7049: l_document := l_document||rpad(l_temp_str,15)||' ';
7050: END IF;
7051: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');
7052: l_temp_str := null;

Line 7051: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');

7047: l_temp_str := null;
7048: l_temp_str := fnd_message.get;
7049: l_document := l_document||rpad(l_temp_str,15)||' ';
7050: END IF;
7051: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');
7052: l_temp_str := null;
7053: l_temp_str := fnd_message.get;
7054: l_document := l_document||rpad(l_temp_str,13);
7055: ELSIF (l_event_type = 'CUSTASSIST' OR l_event_type = 'SALESASSIST') THEN -- For Sales Assistance WF Notification

Line 7053: l_temp_str := fnd_message.get;

7049: l_document := l_document||rpad(l_temp_str,15)||' ';
7050: END IF;
7051: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');
7052: l_temp_str := null;
7053: l_temp_str := fnd_message.get;
7054: l_document := l_document||rpad(l_temp_str,13);
7055: ELSIF (l_event_type = 'CUSTASSIST' OR l_event_type = 'SALESASSIST') THEN -- For Sales Assistance WF Notification
7056: Open c_get_source_code(l_quote_id);
7057: FETCH c_get_source_code into l_quote_source_code;

Line 7060: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');

7056: Open c_get_source_code(l_quote_id);
7057: FETCH c_get_source_code into l_quote_source_code;
7058: Close c_get_source_code;
7059: if (l_quote_source_code = 'IStore InstallBase') then
7060: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
7061: l_temp_str := null;
7062: l_temp_str := fnd_message.get;
7063: l_document := l_document ||rpad(l_temp_str,9)||' ';
7064:

Line 7062: l_temp_str := fnd_message.get;

7058: Close c_get_source_code;
7059: if (l_quote_source_code = 'IStore InstallBase') then
7060: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
7061: l_temp_str := null;
7062: l_temp_str := fnd_message.get;
7063: l_document := l_document ||rpad(l_temp_str,9)||' ';
7064:
7065: end if;
7066: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

Line 7066: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

7062: l_temp_str := fnd_message.get;
7063: l_document := l_document ||rpad(l_temp_str,9)||' ';
7064:
7065: end if;
7066: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7067: l_temp_str := null;
7068: l_temp_str := fnd_message.get;
7069: l_document := l_document ||rpad(l_temp_str,28)||' ';
7070: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

Line 7068: l_temp_str := fnd_message.get;

7064:
7065: end if;
7066: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7067: l_temp_str := null;
7068: l_temp_str := fnd_message.get;
7069: l_document := l_document ||rpad(l_temp_str,28)||' ';
7070: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7071: l_temp_str := null;
7072: l_temp_str := fnd_message.get;

Line 7070: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

7066: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7067: l_temp_str := null;
7068: l_temp_str := fnd_message.get;
7069: l_document := l_document ||rpad(l_temp_str,28)||' ';
7070: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7071: l_temp_str := null;
7072: l_temp_str := fnd_message.get;
7073: l_document := l_document||lpad(l_temp_str,8)||' ';
7074: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

Line 7072: l_temp_str := fnd_message.get;

7068: l_temp_str := fnd_message.get;
7069: l_document := l_document ||rpad(l_temp_str,28)||' ';
7070: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7071: l_temp_str := null;
7072: l_temp_str := fnd_message.get;
7073: l_document := l_document||lpad(l_temp_str,8)||' ';
7074: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7075: l_temp_str := null;
7076: l_temp_str := fnd_message.get;

Line 7074: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

7070: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7071: l_temp_str := null;
7072: l_temp_str := fnd_message.get;
7073: l_document := l_document||lpad(l_temp_str,8)||' ';
7074: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7075: l_temp_str := null;
7076: l_temp_str := fnd_message.get;
7077: l_document := l_document||lpad(l_temp_str,7)||' ';
7078: if (l_quote_source_code <> 'IStore InstallBase') then

Line 7076: l_temp_str := fnd_message.get;

7072: l_temp_str := fnd_message.get;
7073: l_document := l_document||lpad(l_temp_str,8)||' ';
7074: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7075: l_temp_str := null;
7076: l_temp_str := fnd_message.get;
7077: l_document := l_document||lpad(l_temp_str,7)||' ';
7078: if (l_quote_source_code <> 'IStore InstallBase') then
7079: fnd_message.set_name('IBE','Shippable');
7080: l_temp_str := null;

Line 7079: fnd_message.set_name('IBE','Shippable');

7075: l_temp_str := null;
7076: l_temp_str := fnd_message.get;
7077: l_document := l_document||lpad(l_temp_str,7)||' ';
7078: if (l_quote_source_code <> 'IStore InstallBase') then
7079: fnd_message.set_name('IBE','Shippable');
7080: l_temp_str := null;
7081: l_temp_str := fnd_message.get;
7082: l_document := l_document||lpad(l_temp_str,9)||' ';
7083: end if;

Line 7081: l_temp_str := fnd_message.get;

7077: l_document := l_document||lpad(l_temp_str,7)||' ';
7078: if (l_quote_source_code <> 'IStore InstallBase') then
7079: fnd_message.set_name('IBE','Shippable');
7080: l_temp_str := null;
7081: l_temp_str := fnd_message.get;
7082: l_document := l_document||lpad(l_temp_str,9)||' ';
7083: end if;
7084: IF l_view_net_price_flag = 'Y' THEN
7085: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

Line 7085: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

7081: l_temp_str := fnd_message.get;
7082: l_document := l_document||lpad(l_temp_str,9)||' ';
7083: end if;
7084: IF l_view_net_price_flag = 'Y' THEN
7085: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
7086: l_temp_str := null;
7087: l_temp_str := fnd_message.get;
7088: l_document := l_document||lpad(l_temp_str,15)||' ';
7089: END IF;

Line 7087: l_temp_str := fnd_message.get;

7083: end if;
7084: IF l_view_net_price_flag = 'Y' THEN
7085: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
7086: l_temp_str := null;
7087: l_temp_str := fnd_message.get;
7088: l_document := l_document||lpad(l_temp_str,15)||' ';
7089: END IF;
7090: ELSE -- For all other WF notifications (Order conf and Contracts negeotiations)
7091: Open c_get_source_code(l_quote_id);

Line 7096: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');

7092: FETCH c_get_source_code into l_quote_source_code;
7093: Close c_get_source_code;
7094:
7095: if (l_quote_source_code = 'IStore InstallBase') then
7096: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
7097: l_temp_str := null;
7098: l_temp_str := fnd_message.get;
7099: l_document := l_document ||rpad(l_temp_str,9)||' ';
7100:

Line 7098: l_temp_str := fnd_message.get;

7094:
7095: if (l_quote_source_code = 'IStore InstallBase') then
7096: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
7097: l_temp_str := null;
7098: l_temp_str := fnd_message.get;
7099: l_document := l_document ||rpad(l_temp_str,9)||' ';
7100:
7101: end if;
7102: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

Line 7102: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

7098: l_temp_str := fnd_message.get;
7099: l_document := l_document ||rpad(l_temp_str,9)||' ';
7100:
7101: end if;
7102: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7103: l_temp_str := null;
7104: l_temp_str := fnd_message.get;
7105: l_document := l_document ||rpad(l_temp_str,28)||' ';
7106: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

Line 7104: l_temp_str := fnd_message.get;

7100:
7101: end if;
7102: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7103: l_temp_str := null;
7104: l_temp_str := fnd_message.get;
7105: l_document := l_document ||rpad(l_temp_str,28)||' ';
7106: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7107: l_temp_str := null;
7108: l_temp_str := fnd_message.get;

Line 7106: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

7102: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7103: l_temp_str := null;
7104: l_temp_str := fnd_message.get;
7105: l_document := l_document ||rpad(l_temp_str,28)||' ';
7106: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7107: l_temp_str := null;
7108: l_temp_str := fnd_message.get;
7109: l_document := l_document||lpad(l_temp_str,8)||' ';
7110: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

Line 7108: l_temp_str := fnd_message.get;

7104: l_temp_str := fnd_message.get;
7105: l_document := l_document ||rpad(l_temp_str,28)||' ';
7106: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7107: l_temp_str := null;
7108: l_temp_str := fnd_message.get;
7109: l_document := l_document||lpad(l_temp_str,8)||' ';
7110: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7111: l_temp_str := null;
7112: l_temp_str := fnd_message.get;

Line 7110: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

7106: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7107: l_temp_str := null;
7108: l_temp_str := fnd_message.get;
7109: l_document := l_document||lpad(l_temp_str,8)||' ';
7110: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7111: l_temp_str := null;
7112: l_temp_str := fnd_message.get;
7113: l_document := l_document||lpad(l_temp_str,7)||' ';
7114: if (l_quote_source_code <> 'IStore InstallBase') then

Line 7112: l_temp_str := fnd_message.get;

7108: l_temp_str := fnd_message.get;
7109: l_document := l_document||lpad(l_temp_str,8)||' ';
7110: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7111: l_temp_str := null;
7112: l_temp_str := fnd_message.get;
7113: l_document := l_document||lpad(l_temp_str,7)||' ';
7114: if (l_quote_source_code <> 'IStore InstallBase') then
7115: fnd_message.set_name('IBE','Shippable');
7116: l_temp_str := null;

Line 7115: fnd_message.set_name('IBE','Shippable');

7111: l_temp_str := null;
7112: l_temp_str := fnd_message.get;
7113: l_document := l_document||lpad(l_temp_str,7)||' ';
7114: if (l_quote_source_code <> 'IStore InstallBase') then
7115: fnd_message.set_name('IBE','Shippable');
7116: l_temp_str := null;
7117: l_temp_str := fnd_message.get;
7118: l_document := l_document||lpad(l_temp_str,9)||' ';
7119: end if;

Line 7117: l_temp_str := fnd_message.get;

7113: l_document := l_document||lpad(l_temp_str,7)||' ';
7114: if (l_quote_source_code <> 'IStore InstallBase') then
7115: fnd_message.set_name('IBE','Shippable');
7116: l_temp_str := null;
7117: l_temp_str := fnd_message.get;
7118: l_document := l_document||lpad(l_temp_str,9)||' ';
7119: end if;
7120: IF l_view_net_price_flag = 'Y' THEN
7121: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

Line 7121: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

7117: l_temp_str := fnd_message.get;
7118: l_document := l_document||lpad(l_temp_str,9)||' ';
7119: end if;
7120: IF l_view_net_price_flag = 'Y' THEN
7121: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
7122: l_temp_str := null;
7123: l_temp_str := fnd_message.get;
7124: l_document := l_document||lpad(l_temp_str,15)||' ';
7125: END IF;

Line 7123: l_temp_str := fnd_message.get;

7119: end if;
7120: IF l_view_net_price_flag = 'Y' THEN
7121: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
7122: l_temp_str := null;
7123: l_temp_str := fnd_message.get;
7124: l_document := l_document||lpad(l_temp_str,15)||' ';
7125: END IF;
7126: END IF;
7127:

Line 7902: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');

7898: END IF;
7899: END IF;
7900: END LOOP;
7901: IF (l_view_net_price_flag = 'Y' and p_tax_flag = fnd_api.g_true) THEN
7902: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
7903: l_temp_str := null;
7904: l_temp_str := fnd_message.get;
7905: IF (to_char(ord_detail_tbl(i).taxes_total) is not null) THEN
7906: --l_document := l_document ||

Line 7904: l_temp_str := fnd_message.get;

7900: END LOOP;
7901: IF (l_view_net_price_flag = 'Y' and p_tax_flag = fnd_api.g_true) THEN
7902: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
7903: l_temp_str := null;
7904: l_temp_str := fnd_message.get;
7905: IF (to_char(ord_detail_tbl(i).taxes_total) is not null) THEN
7906: --l_document := l_document ||
7907: --lpad(l_temp_str||': '||' '|| to_char(to_number(ord_detail_tbl(i).taxes_total),l_amt_format),72,' ')||NEWLINE;
7908: --ELSE

Line 8295: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');

8291: l_string_in := l_string_left;
8292: END LOOP;
8293:
8294: IF l_view_net_price_flag = 'Y' THEN
8295: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
8296: l_temp_str := null;
8297: l_temp_str := fnd_message.get;
8298:
8299: l_document := l_document ||

Line 8297: l_temp_str := fnd_message.get;

8293:
8294: IF l_view_net_price_flag = 'Y' THEN
8295: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
8296: l_temp_str := null;
8297: l_temp_str := fnd_message.get;
8298:
8299: l_document := l_document ||
8300: lpad(l_temp_str||': '||l_curr_sym|| to_char(g_detail_rec.taxes_total,l_amt_format),72,' ')||
8301: NEWLINE;

Line 8442: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');

8438: l_curr_sym := trim(nvl(curr_sym_rec.symbol,' '));
8439: End Loop;
8440: END IF;
8441: IF l_view_net_price_flag = 'Y' THEN
8442: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
8443: l_temp_str := null;
8444: l_temp_str := fnd_message.get;
8445: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.order_total));
8446: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;

Line 8444: l_temp_str := fnd_message.get;

8440: END IF;
8441: IF l_view_net_price_flag = 'Y' THEN
8442: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
8443: l_temp_str := null;
8444: l_temp_str := fnd_message.get;
8445: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.order_total));
8446: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;
8447:
8448: --Call OM to find the recurring totals

Line 8490: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

8486:
8487: --IF (display_type = 'text/plain' ) THEN
8488: IF l_view_net_price_flag = 'Y' THEN
8489:
8490: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8491: l_temp_str := null;
8492: l_temp_str := fnd_message.get;
8493:
8494: l_sub_total := g_header_rec.lines_total;

Line 8492: l_temp_str := fnd_message.get;

8488: IF l_view_net_price_flag = 'Y' THEN
8489:
8490: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8491: l_temp_str := null;
8492: l_temp_str := fnd_message.get;
8493:
8494: l_sub_total := g_header_rec.lines_total;
8495: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(l_sub_total));
8496: IF l_event_type = 'RETURNORDER' THEN

Line 8503: fnd_message.set_name('IBE','IBE_OT_RET_CHARGES');

8499: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8500: END IF;
8501: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.charges_total));
8502: IF l_event_type = 'RETURNORDER' THEN
8503: fnd_message.set_name('IBE','IBE_OT_RET_CHARGES');
8504: l_temp_str := null;
8505: l_temp_str := fnd_message.get;
8506:
8507: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;

Line 8505: l_temp_str := fnd_message.get;

8501: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.charges_total));
8502: IF l_event_type = 'RETURNORDER' THEN
8503: fnd_message.set_name('IBE','IBE_OT_RET_CHARGES');
8504: l_temp_str := null;
8505: l_temp_str := fnd_message.get;
8506:
8507: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8508: ELSE
8509: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

Line 8509: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

8505: l_temp_str := fnd_message.get;
8506:
8507: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8508: ELSE
8509: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8510: l_temp_str := null;
8511: l_temp_str := fnd_message.get;
8512:
8513: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8511: l_temp_str := fnd_message.get;

8507: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8508: ELSE
8509: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8510: l_temp_str := null;
8511: l_temp_str := fnd_message.get;
8512:
8513: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8514: END IF;
8515: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');

Line 8515: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');

8511: l_temp_str := fnd_message.get;
8512:
8513: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8514: END IF;
8515: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
8516: l_temp_str := null;
8517: l_temp_str := fnd_message.get;
8518: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.taxes_total));
8519: IF l_event_type = 'RETURNORDER' THEN

Line 8517: l_temp_str := fnd_message.get;

8513: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8514: END IF;
8515: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
8516: l_temp_str := null;
8517: l_temp_str := fnd_message.get;
8518: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.taxes_total));
8519: IF l_event_type = 'RETURNORDER' THEN
8520: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8521: ELSE

Line 8526: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');

8522: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8523: END IF;
8524:
8525:
8526: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
8527: l_temp_str := null;
8528: l_temp_str := fnd_message.get;
8529: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.order_total));
8530: IF l_event_type = 'RETURNORDER' THEN

Line 8528: l_temp_str := fnd_message.get;

8524:
8525:
8526: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
8527: l_temp_str := null;
8528: l_temp_str := fnd_message.get;
8529: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.order_total));
8530: IF l_event_type = 'RETURNORDER' THEN
8531: l_document := l_document|| lpad(l_temp_str,44,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 14, ' ')||NEWLINE;
8532: ELSE

Line 8557: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');

8553: l_curr_sym := trim(nvl(curr_sym_rec.symbol,' '));
8554: End Loop;
8555: END IF;
8556: IF l_view_net_price_flag = 'Y' THEN
8557: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
8558: l_temp_str := null;
8559: l_temp_str := fnd_message.get;
8560: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
8561: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;

Line 8559: l_temp_str := fnd_message.get;

8555: END IF;
8556: IF l_view_net_price_flag = 'Y' THEN
8557: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
8558: l_temp_str := null;
8559: l_temp_str := fnd_message.get;
8560: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
8561: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
8562:
8563: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

Line 8563: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

8559: l_temp_str := fnd_message.get;
8560: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
8561: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
8562:
8563: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8564: l_temp_str := null;
8565: l_temp_str := fnd_message.get;
8566: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_lines_total));
8567: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8565: l_temp_str := fnd_message.get;

8561: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
8562:
8563: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8564: l_temp_str := null;
8565: l_temp_str := fnd_message.get;
8566: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_lines_total));
8567: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8568:
8569: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

Line 8569: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

8565: l_temp_str := fnd_message.get;
8566: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_lines_total));
8567: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8568:
8569: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
8570: l_temp_str := null;
8571: l_temp_str := fnd_message.get;
8572: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_taxes_total));
8573: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8571: l_temp_str := fnd_message.get;

8567: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8568:
8569: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
8570: l_temp_str := null;
8571: l_temp_str := fnd_message.get;
8572: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_taxes_total));
8573: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8574:
8575: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

Line 8575: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

8571: l_temp_str := fnd_message.get;
8572: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_taxes_total));
8573: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8574:
8575: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8576: l_temp_str := null;
8577: l_temp_str := fnd_message.get;
8578: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_charges_total));
8579: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8577: l_temp_str := fnd_message.get;

8573: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8574:
8575: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8576: l_temp_str := null;
8577: l_temp_str := fnd_message.get;
8578: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_charges_total));
8579: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8580:
8581: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

Line 8581: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

8577: l_temp_str := fnd_message.get;
8578: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_charges_total));
8579: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8580:
8581: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
8582: l_temp_str := null;
8583: l_temp_str := fnd_message.get;
8584: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_order_total));
8585: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');

Line 8583: l_temp_str := fnd_message.get;

8579: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8580:
8581: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
8582: l_temp_str := null;
8583: l_temp_str := fnd_message.get;
8584: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_order_total));
8585: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');
8586: END IF;
8587: END LOOP;

Line 8947: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_ID_COLON');

8943: ibe_util.debug('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id);
8944: END IF;
8945:
8946: --IF (display_type = 'text/plain' ) THEN
8947: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_ID_COLON');
8948: l_temp_str := null;
8949: l_temp_str := fnd_message.get;
8950: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8951:

Line 8949: l_temp_str := fnd_message.get;

8945:
8946: --IF (display_type = 'text/plain' ) THEN
8947: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_ID_COLON');
8948: l_temp_str := null;
8949: l_temp_str := fnd_message.get;
8950: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8951:
8952: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');
8953: l_temp_str := null;

Line 8952: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');

8948: l_temp_str := null;
8949: l_temp_str := fnd_message.get;
8950: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8951:
8952: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');
8953: l_temp_str := null;
8954: l_temp_str := fnd_message.get;
8955: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8956:

Line 8954: l_temp_str := fnd_message.get;

8950: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8951:
8952: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');
8953: l_temp_str := null;
8954: l_temp_str := fnd_message.get;
8955: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8956:
8957: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');
8958: l_temp_str := null;

Line 8957: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');

8953: l_temp_str := null;
8954: l_temp_str := fnd_message.get;
8955: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8956:
8957: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');
8958: l_temp_str := null;
8959: l_temp_str := fnd_message.get;
8960: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8961: /*

Line 8959: l_temp_str := fnd_message.get;

8955: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8956:
8957: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');
8958: l_temp_str := null;
8959: l_temp_str := fnd_message.get;
8960: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8961: /*
8962: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
8963: l_temp_str := null;

Line 8962: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

8958: l_temp_str := null;
8959: l_temp_str := fnd_message.get;
8960: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8961: /*
8962: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
8963: l_temp_str := null;
8964: l_temp_str := fnd_message.get;
8965: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8966: */

Line 8964: l_temp_str := fnd_message.get;

8960: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8961: /*
8962: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
8963: l_temp_str := null;
8964: l_temp_str := fnd_message.get;
8965: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8966: */
8967: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
8968: l_temp_str := null;

Line 8967: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

8963: l_temp_str := null;
8964: l_temp_str := fnd_message.get;
8965: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8966: */
8967: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
8968: l_temp_str := null;
8969: l_temp_str := fnd_message.get;
8970: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8971:

Line 8969: l_temp_str := fnd_message.get;

8965: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8966: */
8967: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
8968: l_temp_str := null;
8969: l_temp_str := fnd_message.get;
8970: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8971:
8972: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
8973: l_temp_str := null;

Line 8972: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');

8968: l_temp_str := null;
8969: l_temp_str := fnd_message.get;
8970: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8971:
8972: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
8973: l_temp_str := null;
8974: l_temp_str := fnd_message.get;
8975: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8976:

Line 8974: l_temp_str := fnd_message.get;

8970: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8971:
8972: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
8973: l_temp_str := null;
8974: l_temp_str := fnd_message.get;
8975: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8976:
8977: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8978: l_temp_str := null;

Line 8977: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

8973: l_temp_str := null;
8974: l_temp_str := fnd_message.get;
8975: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8976:
8977: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8978: l_temp_str := null;
8979: l_temp_str := fnd_message.get;
8980: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8981:

Line 8979: l_temp_str := fnd_message.get;

8975: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8976:
8977: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8978: l_temp_str := null;
8979: l_temp_str := fnd_message.get;
8980: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8981:
8982: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
8983: l_temp_str := null;

Line 8982: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');

8978: l_temp_str := null;
8979: l_temp_str := fnd_message.get;
8980: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8981:
8982: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
8983: l_temp_str := null;
8984: l_temp_str := fnd_message.get;
8985: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8986:

Line 8984: l_temp_str := fnd_message.get;

8980: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8981:
8982: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
8983: l_temp_str := null;
8984: l_temp_str := fnd_message.get;
8985: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8986:
8987: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
8988: l_temp_str := null;

Line 8987: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');

8983: l_temp_str := null;
8984: l_temp_str := fnd_message.get;
8985: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8986:
8987: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
8988: l_temp_str := null;
8989: l_temp_str := fnd_message.get;
8990: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
8991:

Line 8989: l_temp_str := fnd_message.get;

8985: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8986:
8987: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
8988: l_temp_str := null;
8989: l_temp_str := fnd_message.get;
8990: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
8991:
8992:
8993: If not(l_event_type = 'TERMREJECTED') Then

Line 8999: fnd_message.set_name('IBE','IBE_PRMT_ADDL_TERMS_COLON');

8995: itemtype => l_item_type,
8996: itemkey => l_item_key,
8997: aname => 'COMMENTS'
8998: );
8999: fnd_message.set_name('IBE','IBE_PRMT_ADDL_TERMS_COLON');
9000: l_temp_str := null;
9001: l_temp_str := fnd_message.get;
9002: l_document := l_document || l_temp_str ||TAB||l_comments ||NEWLINE;
9003: End If;

Line 9001: l_temp_str := fnd_message.get;

8997: aname => 'COMMENTS'
8998: );
8999: fnd_message.set_name('IBE','IBE_PRMT_ADDL_TERMS_COLON');
9000: l_temp_str := null;
9001: l_temp_str := fnd_message.get;
9002: l_document := l_document || l_temp_str ||TAB||l_comments ||NEWLINE;
9003: End If;
9004:
9005: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');

Line 9005: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');

9001: l_temp_str := fnd_message.get;
9002: l_document := l_document || l_temp_str ||TAB||l_comments ||NEWLINE;
9003: End If;
9004:
9005: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
9006: l_temp_str := null;
9007: l_temp_str := fnd_message.get;
9008: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9009:

Line 9007: l_temp_str := fnd_message.get;

9003: End If;
9004:
9005: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
9006: l_temp_str := null;
9007: l_temp_str := fnd_message.get;
9008: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9009:
9010: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
9011: l_temp_str := null;

Line 9010: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

9006: l_temp_str := null;
9007: l_temp_str := fnd_message.get;
9008: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9009:
9010: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
9011: l_temp_str := null;
9012: l_temp_str := fnd_message.get;
9013: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
9014:

Line 9012: l_temp_str := fnd_message.get;

9008: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9009:
9010: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
9011: l_temp_str := null;
9012: l_temp_str := fnd_message.get;
9013: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
9014:
9015: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
9016: l_temp_str := null;

Line 9015: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

9011: l_temp_str := null;
9012: l_temp_str := fnd_message.get;
9013: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
9014:
9015: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
9016: l_temp_str := null;
9017: l_temp_str := fnd_message.get;
9018: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
9019:

Line 9017: l_temp_str := fnd_message.get;

9013: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
9014:
9015: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
9016: l_temp_str := null;
9017: l_temp_str := fnd_message.get;
9018: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
9019:
9020: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
9021: l_temp_str := null;

Line 9020: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

9016: l_temp_str := null;
9017: l_temp_str := fnd_message.get;
9018: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
9019:
9020: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
9021: l_temp_str := null;
9022: l_temp_str := fnd_message.get;
9023: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
9024:

Line 9022: l_temp_str := fnd_message.get;

9018: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
9019:
9020: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
9021: l_temp_str := null;
9022: l_temp_str := fnd_message.get;
9023: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
9024:
9025: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
9026: l_temp_str := null;

Line 9025: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

9021: l_temp_str := null;
9022: l_temp_str := fnd_message.get;
9023: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
9024:
9025: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
9026: l_temp_str := null;
9027: l_temp_str := fnd_message.get;
9028: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
9029:

Line 9027: l_temp_str := fnd_message.get;

9023: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
9024:
9025: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
9026: l_temp_str := null;
9027: l_temp_str := fnd_message.get;
9028: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
9029:
9030: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
9031: l_temp_str := null;

Line 9030: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');

9026: l_temp_str := null;
9027: l_temp_str := fnd_message.get;
9028: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
9029:
9030: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
9031: l_temp_str := null;
9032: l_temp_str := fnd_message.get;
9033: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
9034:

Line 9032: l_temp_str := fnd_message.get;

9028: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
9029:
9030: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
9031: l_temp_str := null;
9032: l_temp_str := fnd_message.get;
9033: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
9034:
9035: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
9036: l_temp_str := null;

Line 9035: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

9031: l_temp_str := null;
9032: l_temp_str := fnd_message.get;
9033: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
9034:
9035: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
9036: l_temp_str := null;
9037: l_temp_str := fnd_message.get;
9038: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
9039:

Line 9037: l_temp_str := fnd_message.get;

9033: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
9034:
9035: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
9036: l_temp_str := null;
9037: l_temp_str := fnd_message.get;
9038: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
9039:
9040: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
9041: l_temp_str := null;

Line 9040: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

9036: l_temp_str := null;
9037: l_temp_str := fnd_message.get;
9038: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
9039:
9040: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
9041: l_temp_str := null;
9042: l_temp_str := fnd_message.get;
9043: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
9044:

Line 9042: l_temp_str := fnd_message.get;

9038: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
9039:
9040: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
9041: l_temp_str := null;
9042: l_temp_str := fnd_message.get;
9043: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
9044:
9045: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
9046: l_temp_str := null;

Line 9045: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

9041: l_temp_str := null;
9042: l_temp_str := fnd_message.get;
9043: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
9044:
9045: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
9046: l_temp_str := null;
9047: l_temp_str := fnd_message.get;
9048: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
9049:

Line 9047: l_temp_str := fnd_message.get;

9043: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
9044:
9045: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
9046: l_temp_str := null;
9047: l_temp_str := fnd_message.get;
9048: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
9049:
9050: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9051: l_temp_str := null;

Line 9050: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

9046: l_temp_str := null;
9047: l_temp_str := fnd_message.get;
9048: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
9049:
9050: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9051: l_temp_str := null;
9052: l_temp_str := fnd_message.get;
9053: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
9054:

Line 9052: l_temp_str := fnd_message.get;

9048: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
9049:
9050: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9051: l_temp_str := null;
9052: l_temp_str := fnd_message.get;
9053: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
9054:
9055: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
9056: l_temp_str := null;

Line 9055: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');

9051: l_temp_str := null;
9052: l_temp_str := fnd_message.get;
9053: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
9054:
9055: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
9056: l_temp_str := null;
9057: l_temp_str := fnd_message.get;
9058: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9059:

Line 9057: l_temp_str := fnd_message.get;

9053: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
9054:
9055: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
9056: l_temp_str := null;
9057: l_temp_str := fnd_message.get;
9058: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9059:
9060: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
9061: l_temp_str := null;

Line 9060: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

9056: l_temp_str := null;
9057: l_temp_str := fnd_message.get;
9058: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9059:
9060: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
9061: l_temp_str := null;
9062: l_temp_str := fnd_message.get;
9063: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
9064:

Line 9062: l_temp_str := fnd_message.get;

9058: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
9059:
9060: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
9061: l_temp_str := null;
9062: l_temp_str := fnd_message.get;
9063: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
9064:
9065: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
9066: l_temp_str := null;

Line 9065: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

9061: l_temp_str := null;
9062: l_temp_str := fnd_message.get;
9063: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
9064:
9065: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
9066: l_temp_str := null;
9067: l_temp_str := fnd_message.get;
9068: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
9069:

Line 9067: l_temp_str := fnd_message.get;

9063: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
9064:
9065: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
9066: l_temp_str := null;
9067: l_temp_str := fnd_message.get;
9068: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
9069:
9070: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
9071: l_temp_str := null;

Line 9070: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

9066: l_temp_str := null;
9067: l_temp_str := fnd_message.get;
9068: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
9069:
9070: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
9071: l_temp_str := null;
9072: l_temp_str := fnd_message.get;
9073: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
9074:

Line 9072: l_temp_str := fnd_message.get;

9068: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
9069:
9070: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
9071: l_temp_str := null;
9072: l_temp_str := fnd_message.get;
9073: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
9074:
9075: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
9076: l_temp_str := null;

Line 9075: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

9071: l_temp_str := null;
9072: l_temp_str := fnd_message.get;
9073: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
9074:
9075: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
9076: l_temp_str := null;
9077: l_temp_str := fnd_message.get;
9078: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
9079:

Line 9077: l_temp_str := fnd_message.get;

9073: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
9074:
9075: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
9076: l_temp_str := null;
9077: l_temp_str := fnd_message.get;
9078: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
9079:
9080: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
9081: l_temp_str := null;

Line 9080: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

9076: l_temp_str := null;
9077: l_temp_str := fnd_message.get;
9078: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
9079:
9080: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
9081: l_temp_str := null;
9082: l_temp_str := fnd_message.get;
9083: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
9084:

Line 9082: l_temp_str := fnd_message.get;

9078: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
9079:
9080: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
9081: l_temp_str := null;
9082: l_temp_str := fnd_message.get;
9083: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
9084:
9085: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
9086: l_temp_str := null;

Line 9085: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

9081: l_temp_str := null;
9082: l_temp_str := fnd_message.get;
9083: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
9084:
9085: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
9086: l_temp_str := null;
9087: l_temp_str := fnd_message.get;
9088: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
9089:

Line 9087: l_temp_str := fnd_message.get;

9083: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
9084:
9085: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
9086: l_temp_str := null;
9087: l_temp_str := fnd_message.get;
9088: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
9089:
9090: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
9091: l_temp_str := null;

Line 9090: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

9086: l_temp_str := null;
9087: l_temp_str := fnd_message.get;
9088: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
9089:
9090: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
9091: l_temp_str := null;
9092: l_temp_str := fnd_message.get;
9093: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
9094:

Line 9092: l_temp_str := fnd_message.get;

9088: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
9089:
9090: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
9091: l_temp_str := null;
9092: l_temp_str := fnd_message.get;
9093: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
9094:
9095: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9096: l_temp_str := null;

Line 9095: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

9091: l_temp_str := null;
9092: l_temp_str := fnd_message.get;
9093: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
9094:
9095: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9096: l_temp_str := null;
9097: l_temp_str := fnd_message.get;
9098: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_fax||NEWLINE;
9099:

Line 9097: l_temp_str := fnd_message.get;

9093: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
9094:
9095: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9096: l_temp_str := null;
9097: l_temp_str := fnd_message.get;
9098: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_fax||NEWLINE;
9099:
9100: --ELSE
9101: --null;

Line 9375: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');

9371: For curr_sym_rec In c_curr_symbol(g_quote_header_rec.Currency_code) Loop
9372: l_curr_sym := trim(curr_sym_rec.symbol);
9373: End Loop;
9374:
9375: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
9376: l_temp_str := null;
9377: l_temp_str := fnd_message.get;
9378: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9379: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;

Line 9377: l_temp_str := fnd_message.get;

9373: End Loop;
9374:
9375: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
9376: l_temp_str := null;
9377: l_temp_str := fnd_message.get;
9378: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9379: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;
9380:
9381: OPEN c_reccur_quote_footer(l_quote_id);

Line 9419: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

9415:
9416: --IF (display_type = 'text/plain' ) THEN
9417: IF l_view_net_price_flag = 'Y' THEN
9418:
9419: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9420: l_temp_str := null;
9421: l_temp_str := fnd_message.get;
9422:
9423: l_sub_total := g_quote_header_rec.total_list_price - abs(g_quote_header_rec.total_adjusted_amount);

Line 9421: l_temp_str := fnd_message.get;

9417: IF l_view_net_price_flag = 'Y' THEN
9418:
9419: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9420: l_temp_str := null;
9421: l_temp_str := fnd_message.get;
9422:
9423: l_sub_total := g_quote_header_rec.total_list_price - abs(g_quote_header_rec.total_adjusted_amount);
9424: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(l_sub_total));
9425: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad( l_curr_sym||to_char(to_number(l_can_amt),l_amt_format), 20, ' ')|| NEWLINE;

Line 9428: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

9424: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(l_sub_total));
9425: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad( l_curr_sym||to_char(to_number(l_can_amt),l_amt_format), 20, ' ')|| NEWLINE;
9426:
9427:
9428: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9429: l_temp_str := null;
9430: l_temp_str := fnd_message.get;
9431: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_shipping_charge));
9432: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')|| NEWLINE;

Line 9430: l_temp_str := fnd_message.get;

9426:
9427:
9428: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9429: l_temp_str := null;
9430: l_temp_str := fnd_message.get;
9431: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_shipping_charge));
9432: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')|| NEWLINE;
9433:
9434:

Line 9435: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');

9431: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_shipping_charge));
9432: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')|| NEWLINE;
9433:
9434:
9435: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
9436: l_temp_str := null;
9437: l_temp_str := fnd_message.get;
9438: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_tax));
9439: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;

Line 9437: l_temp_str := fnd_message.get;

9433:
9434:
9435: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
9436: l_temp_str := null;
9437: l_temp_str := fnd_message.get;
9438: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_tax));
9439: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;
9440:
9441: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');

Line 9441: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');

9437: l_temp_str := fnd_message.get;
9438: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_tax));
9439: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;
9440:
9441: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
9442: l_temp_str := null;
9443: l_temp_str := fnd_message.get;
9444: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9445: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym|| to_char(to_number(l_can_amt),l_amt_format),20,' ');

Line 9443: l_temp_str := fnd_message.get;

9439: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;
9440:
9441: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
9442: l_temp_str := null;
9443: l_temp_str := fnd_message.get;
9444: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9445: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym|| to_char(to_number(l_can_amt),l_amt_format),20,' ');
9446: END IF;
9447: --ELSE

Line 9467: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');

9463: l_curr_sym := trim(curr_sym_rec.symbol);
9464: End Loop;
9465: END IF;
9466: IF l_view_net_price_flag = 'Y' THEN
9467: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
9468: l_temp_str := null;
9469: l_temp_str := fnd_message.get;
9470: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
9471: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;

Line 9469: l_temp_str := fnd_message.get;

9465: END IF;
9466: IF l_view_net_price_flag = 'Y' THEN
9467: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
9468: l_temp_str := null;
9469: l_temp_str := fnd_message.get;
9470: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
9471: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
9472:
9473: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

Line 9473: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

9469: l_temp_str := fnd_message.get;
9470: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
9471: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
9472:
9473: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9474: l_temp_str := null;
9475: l_temp_str := fnd_message.get;
9476: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_lines_total));
9477: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 9475: l_temp_str := fnd_message.get;

9471: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
9472:
9473: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9474: l_temp_str := null;
9475: l_temp_str := fnd_message.get;
9476: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_lines_total));
9477: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9478:
9479: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

Line 9479: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

9475: l_temp_str := fnd_message.get;
9476: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_lines_total));
9477: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9478:
9479: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
9480: l_temp_str := null;
9481: l_temp_str := fnd_message.get;
9482: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_taxes_total));
9483: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 9481: l_temp_str := fnd_message.get;

9477: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9478:
9479: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
9480: l_temp_str := null;
9481: l_temp_str := fnd_message.get;
9482: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_taxes_total));
9483: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9484:
9485: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

Line 9485: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

9481: l_temp_str := fnd_message.get;
9482: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_taxes_total));
9483: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9484:
9485: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9486: l_temp_str := null;
9487: l_temp_str := fnd_message.get;
9488: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_charges_total));
9489: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 9487: l_temp_str := fnd_message.get;

9483: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9484:
9485: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9486: l_temp_str := null;
9487: l_temp_str := fnd_message.get;
9488: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_charges_total));
9489: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9490:
9491: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

Line 9491: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

9487: l_temp_str := fnd_message.get;
9488: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_charges_total));
9489: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9490:
9491: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
9492: l_temp_str := null;
9493: l_temp_str := fnd_message.get;
9494: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_order_total));
9495: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');

Line 9493: l_temp_str := fnd_message.get;

9489: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9490:
9491: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
9492: l_temp_str := null;
9493: l_temp_str := fnd_message.get;
9494: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_order_total));
9495: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');
9496: END IF;
9497: END LOOP;

Line 10167: PROCEDURE get_FND_message(

10163: document_type := 'text/plain';
10164: END IF;
10165: END ;
10166:
10167: PROCEDURE get_FND_message(
10168: document_id IN VARCHAR2,
10169: display_type IN VARCHAR2,
10170: document IN OUT NOCOPY VARCHAR2,
10171: document_type IN OUT NOCOPY VARCHAR2

Line 10176: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);

10172: ) is
10173:
10174: BEGIN
10175: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10176: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);
10177: END IF;
10178: FND_MESSAGE.set_name('IBE',document_id);
10179: document:=FND_MESSAGE.get();
10180:

Line 10178: FND_MESSAGE.set_name('IBE',document_id);

10174: BEGIN
10175: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10176: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);
10177: END IF;
10178: FND_MESSAGE.set_name('IBE',document_id);
10179: document:=FND_MESSAGE.get();
10180:
10181: IF(display_type = 'text/html') THEN
10182: document_type := 'text/html';

Line 10179: document:=FND_MESSAGE.get();

10175: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10176: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);
10177: END IF;
10178: FND_MESSAGE.set_name('IBE',document_id);
10179: document:=FND_MESSAGE.get();
10180:
10181: IF(display_type = 'text/html') THEN
10182: document_type := 'text/html';
10183: ELSE

Line 10187: END get_FND_message;

10183: ELSE
10184: document_type := 'text/plain';
10185: END IF;
10186:
10187: END get_FND_message;
10188:
10189: PROCEDURE get_date(
10190: document_id IN VARCHAR2,
10191: display_type IN VARCHAR2,

Line 10325: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');

10321: l_string_in := l_string_left;
10322: END LOOP;
10323: IF(tax_flag = fnd_api.g_true) then
10324: IF view_net_price_flag = 'Y' THEN
10325: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
10326: l_temp_str := null;
10327: l_temp_str := fnd_message.get;
10328: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(Notif_Line_Tbl(counter).TaxAmount));
10329: ldocument := ldocument ||lpad(l_temp_str||': '||l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),72,' ')||NEWLINE;

Line 10327: l_temp_str := fnd_message.get;

10323: IF(tax_flag = fnd_api.g_true) then
10324: IF view_net_price_flag = 'Y' THEN
10325: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
10326: l_temp_str := null;
10327: l_temp_str := fnd_message.get;
10328: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(Notif_Line_Tbl(counter).TaxAmount));
10329: ldocument := ldocument ||lpad(l_temp_str||': '||l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),72,' ')||NEWLINE;
10330: END IF;
10331: END IF;